package com.ebuy.api.base.config;


import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import com.github.pagehelper.PageInterceptor;
import com.github.pagehelper.autoconfigure.PageHelperProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;


@Configuration
public class MybatisPageConfig {
    /**
     * mybatis-plus分页
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));//如果配置多个插件,切记分页最后添加
        //interceptor.addInnerInterceptor(new PaginationInnerInterceptor()); 如果有多数据源可以不配具体类型 否则都建议配上具体的DbType
        return interceptor;
    }

    /**
     * pageHelper分页
     * @return
     */
//    @Bean
//    PageInterceptor pageInterceptor() {
//        PageInterceptor pageInterceptor = new PageInterceptor();
//        PageHelperProperties properties = new PageHelperProperties();
//        properties.setHelperDialect("mysql");
//        properties.setReasonable(Boolean.TRUE);
//        properties.setSupportMethodsArguments(Boolean.TRUE);
//        properties.setParams("count=countsql");
//        pageInterceptor.setProperties(properties);
//        return pageInterceptor;
//    }

}
